To run the query click Run on the
toolbar. If the query statement is correct, the query executes and, if te query
statement is supposed to return data, the Result tab opens with the data returned by the query.
If an error occurs while executing the query, execution stops, the appropriate error message
is displayed.
The Result tab displays the result data, returned by the query, as
a grid. Data can be displayed in three mode: Grid View, Form View and Text/Blob
View. See Data View for details.
Note: You can choose to show the Result tab below the query editor or in a new tab by selecting Edit -> Show Result -> Below Query Editor or In a New Tab.
The toolbars of Query Result Viewer provides the following functions for managing data:
- Export Query Results
Export data to TXT, CSV, DBF, XML and MS Excel. - Edit TEXT/BLOB/BFile
Allow you to view and edit the content of TEXT/BLOB/BFile fields.
Note: Only Oracle supports BFile.